create table sys_user_role
(
    user_id bigint not null,
    role_id bigint not null,
    primary key (user_id, role_id)
)
go

exec sp_addextendedproperty 'MS_Description', '用户和角色关联表', 'SCHEMA', 'dbo', 'TABLE', 'sys_user_role'
go

exec sp_addextendedproperty 'MS_Description', '用户ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_user_role', 'COLUMN', 'user_id'
go

exec sp_addextendedproperty 'MS_Description', '角色ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_user_role', 'COLUMN', 'role_id'
go

INSERT INTO [ry-vue].dbo.sys_user_role (user_id, role_id) VALUES (1, 1);
INSERT INTO [ry-vue].dbo.sys_user_role (user_id, role_id) VALUES (2, 2);
INSERT INTO [ry-vue].dbo.sys_user_role (user_id, role_id) VALUES (3, 2);
INSERT INTO [ry-vue].dbo.sys_user_role (user_id, role_id) VALUES (4, 4);
INSERT INTO [ry-vue].dbo.sys_user_role (user_id, role_id) VALUES (5, 5);